//模型创建 https://www.sequelize.com.cn/core-concepts/model-basics#%E5%AD%97%E7%AC%A6%E4%B8%B2

//分类
module.exports = ( sequelize, Sequelize ) => {
    return sequelize.define( "information", {
        id: {
            type: Sequelize.UUID,
            notNull: true,
            primaryKey: true,
            defaultValue: Sequelize.UUIDV4 // 或 DataTypes.UUIDV1
        },
        name: {
            type: Sequelize.STRING,
            notNull: true,
            comment: '名字',
             
        },
        post: {
            type: Sequelize.STRING,
             notNull: true,
            comment: '职称',
        },
        motto: {
            type: Sequelize.STRING,
             notNull: true,
            comment: '座右铭',
        },
        workYears: {
            type: Sequelize.INTEGER,
             notNull: true,
             comment: '工作年限',
        },
       projectItems: {
           type: Sequelize.INTEGER,
            notNull: true,
           comment: '项目数',
        },
       companyNum: {
           type: Sequelize.INTEGER,
            notNull: true,
           comment: '公司数',
        },
        attachmentResume: {
             type: Sequelize.TEXT,
             comment: '附件简历',
        },
        head: {
            type: Sequelize.TEXT,
            comment: '头像',
        },
        selfIntroduction: {
             type: Sequelize.TEXT,
                 comment: '自我介绍',
        },
         phone: {
             type: Sequelize.STRING,
             notNull: true,
             comment: '微信/电话',

        },
         email: {
             type: Sequelize.STRING,
             notNull: true,
             comment: '电子邮件',
        },
          QQ: {
              type: Sequelize.STRING,
              notNull: true,
              comment: 'QQ',

        },
          position: {
              type: Sequelize.STRING,
              notNull: true,
              comment: '位置',

        },
          age: {
              type: Sequelize.INTEGER,
              comment: '年龄',
        },
          birthDate: {
              type: Sequelize.DATE,
              comment: '出生年月',

        },
          school: {
              type: Sequelize.STRING,
              comment: '毕业院校',
        },
           major: {
               type: Sequelize.STRING,
               comment: '专业',
        },
           education: {
               type: Sequelize.STRING,
               comment: '学历',
           },
    }, {
        tableName: 'information'
    } );
};
